package com.nameli.SIM.mapper;

import com.nameli.SIM.bean.entity.FacultyInfo;
import com.nameli.SIM.bean.query.FacultyQuery;
import com.nameli.SIM.bean.vo.FacultyVO;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

/**
 * @author NAME-L
 * @Description 院系信息Mapper接口
 * @className FacultyInfoMapper
 * @date 2021-11-01 16:09:23
 */
@Mapper
public interface FacultyInfoMapper {

    /**
     * 通过学部编号查找数量
     * @param departmentNo 学部编号
     * @return count
     */
    int queryByDepartmentNo(String departmentNo);

    /**
     * 根据学部编号查找院系，用于级联选择器
     * @return List<Map<String, Object>>
     */
    List<Map<String, Object>> queryByDepartNo(String departNo);


    /**
     * 查找所有的院系信息
     * @return
     */
    List<FacultyVO> queryAllFaculty();

    /**
     * 查找所有的院系信息
     * @return
     */
    List<FacultyVO> queryByCondition(FacultyQuery facultyQuery);
}
